Northwind Test with Yukon

Ten Most Expensive Products Stored Procedure

Owner

dbo

Creation Date

10-07-2003 10:31:36

Remarks


Source Code

create procedure "Ten Most Expensive Products" AS
SET ROWCOUNT 10
SELECT Products.ProductName AS TenMostExpensiveProducts, Products.UnitPrice
FROM Products
ORDER BY Products.UnitPrice DESC